MacDonald's Menu Card Analysis

i'm lovin' it

INDEX


Intro: MacD, The Golden Arches, The American Dream
Reposrt Summary
Explanatory Data Analysis
1. Overview of Data Set
2. Statistical Overview of Data
3. Unique value in the Category
4. Number of Items in Each Category
5. Plotting Food Category having higest and lowest variety of Item
6. Analysis of Variables with Outliers
7. Correlations between Variables
8. Category of Menu Contributing to max% of Cholesterol
9. Item of the Menu Contributing to the max intake of Sodium

10. Food Item which contributes most amount of Saturated Fat
11. Analysis of Nutrients across Category of Macdonalds Menu

12. Analysis of Carbohydrates vs Sugar
13. Ordering Crispy(fried) chiken or Grilled Chicken
Conclusion


MacD, The Golden Arches, The American Dream

MacDonald brthers , Richard and Maurice McDonald american food entrepuneurs started the Orginal Macdonald in 1940 at San Barnadino, Califonia with the Usp of "Speedee Service System".By September 13,1961 McDonald's, under the guidance of Ray Kroc, filed for a trademark on a new logo—an overlapping, double-arched "M" symbol.That Marks the start of the Golden Arches and became a prominent milestone in the capter of "American Dreams".

As of 2021 MacDoland marks its presence in more than 100 countries, serving millions of people everyday. But how did Macdoland become what it is today. The business model is simple, FRANCHISES.

Firstly, Ray Croc had simple moto of "Maintaining Quality","Maintaining Service Consistancy","Maintaining Cleanliness", "Maintaining Value" across all the franchise outlet. He went on to establish the Hamburger University to teach the franchise to main the consistence.

Secondly Macdonald have a incorgible behavior of adapting to the culture of the country. Example India were it amazingly adapted to the vegeterian maintaing the same Quality,Service,cleanliness and Value of the food.

Thirdly, Brand presence "I'm lovin it" is an emotion with people of many country which reminds them of their childhood.

Fourthly, its ability to innovate, 1975 Macdolads invented the drive away for the customers were you do not need to get out of the car to order to take your food.in the mordern world of technology they also have adpated quickly to idea of delivery with better packaging than most of their compititors.

But Most of Macdoland Profit do not come from selling burgers but from rent!!! How ????

Macdonald according to most analyst is reccesion free. Its actually the 5th largest realestate company in the world.85% of the Macdonalds are owned by people who are willing to take a franchise of the brand name in return of a fee(rent) and Macdonald contract comes with multile clause like vendors from whom you can buy the raw materials even if they are higher price. Thats how one doesnt gets to undertsand the difference of taste of food from outlet to outlet.

Macdonald have a decade of exeprince in buying and selling of plot. So, the person who is franchising the brand name has to open the outlet in a prime location owned and choosed by Macdonalds, in return of which the franchise give Macdonald rent and franchise fee and equipment fee.And if the franchise at a location fails to run the business or draw traffic Macdonald Corporation simply find a new tenant("Franchise") to run the business or sell the land.

Report Sumary

The Data set provide is the nutrition value of the all the category of food and beverages sold in MacDonald and all the items under each categories of Food and Beverages.The Data was analysed using Python and Pythons Library.Inference to the Analysis done is also shared along with the graphical representation.

The below analysis will involve the use of Pandas, Numpy, Matplotlip, Seaborn, Scipy, Pyplot and Plotly express.


Explanatory Data Analysis

1. Checking the overview (information) the data set

INFERENCE

1. There are no Null values in the data set.

2. Only Category and Items are categorical variables and other 22 variables are numerical variable.

3. columns like Total Fat, Cholesterol, etc. have 2 columns where the first one denotes the quantity in grams and “% Daily Value” can tell you if serving of food is high or low in a nutrient.


2. Understanding of the statistically overview of the data

INFERENCE

1. The above table helps to identify the continuos number columns as the describe function by default only displays the continous number.

2. The table also provides crucial data about the Mean, Standart devition, min,max, 1st quartlie, 2nd quartile and 3rd quartile of the variables


3. Unique values in the Category Column

4. Number of Items in each Category (Question 1)

5. Ploting Food Category having the higest and lowest of the variety of Items (Question 1)

INFERENCE( from 4 & 5 )

1. Coffee & Tea have the highest variety of Items.

2. Salad has the least variety of items.So may be people of diet and looking for salads, Macdonalds in not a good place to visit. And vice versa those people are not the targeted audience of Macdonald .


6. Analysis of the columns to find which variables have outliers (Question 2)

To find the outliers in the variable we will only be using the columns displayed in the Statistics Overview Table as by default describe function returns statistical over view of the columns which contains continous numbers. And Outliers can only be predicted for continous number variable.

Secondly, Analysing variables like Total Fat (% Daily Value), Cholesterol (% Daily Value) etc are derived variables from Total Fat, Cholesterol etc respectly. So there is no pooint in analysing the same as if Total Fat contains outliers, Total Fat (% Daily Value) will also contain outliers

INFERENCE

As per the Box Plot analysis done above the following variable has Outliers:

1. Serving Size

2. Calories

3. Calories from Fat

4. Total Fat

5. Trans Fat

6. Cholesterol

7. Sodium

8. Carbohydrates

9. Sugars

10. Protein

11. Vitamin A

12. Vitamin C

13. Calcium

14. Iron


7. Corrlation between Variables (Question 3)

The above table shows the correlation between all the variables in the data set but we are generally concernd with Calories, Protein, Fat, Carbohydrate, Sugar and Dietary Fiber. So lets see a consentrated Heatmap to find the correlation betwee the above variable so, that it helps to choose our next Macdonald menu when we are on diet.

8. Category of Menu which contributes to maximum % of Cholesterol (Question 4)

INFERENCE

1. Breakfast Category contribute to most cholestrol. So, when you are entering the Macdolads for a breakfast, think twice !!!


9. Item of Menu which contributes to maximum to Sodium Intake (Question 5)

INFERENCE

Chicken McNuggets has the most amount of Sodium.


10. 4 Foods(Items) which contains most amount of Sarurated Fa (Question 6)

INFERENCE

The above table 4 Food Item which contributes to maximum number of Saturated Fat are :

1. McFlurry with M&M’s Candies (Medium)

2. Big Breakfast with Hotcakes (Large Biscuit)

3. Chicken McNuggets (40 piece)

4. Frappé Chocolate Chip (Large)


11. Analysis of Major Nutrients across Category of Macdonald Food Menu

Under the category of major nutrients comes Carbohydrates, Proteins, Fats, Vitamins, Minerals, Dietary fibre, Water.But as all the neccessary variables are not available for us we will be doing the analysis based on Proteins, Total Fat,Vitamin A, Dietary Fiber only.

10.1. Analysis of Proteins

INFERENCE

Chicken and Fish Category has most amount of Protien.


10.2. Analysis of Total Fat